<!DOCTYPE html>
<html lang="zh-CN">
<head>
    <title>sql执行接口 - 数据仓库 open api</title>
    <meta charset="utf-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1" />
    <link rel="shortcut icon" href="./favicon.ico" />
    <script type="text/javascript" src="js/plugin/jquery.min.js"></script>
    <script type="text/javascript" src="js/plugin/jquery.cookie.js"></script>
    <script type="text/javascript" src="js/plugin/echarts/echarts.min.js"></script>
    <script type="text/javascript" src="js/plugin/echarts/charts.js"></script>
    <script type="text/javascript" src="js/plugin/tablesorter/jquery.tablesorter.js"></script>
    <script type="text/javascript" src="js/apiTest.js"></script>
    <script type="text/javascript" src="js/plugin/bootstrap-3.3.5/js/bootstrap.min.js"></script>
    <script type="text/javascript" src="js/plugin/bootstrap-3.3.5/js/bootstrap-select.min.js"></script>
    <script type="text/javascript" src="js/plugin/bootstrap-3.3.5/js/defaults-zh_CN.min.js"></script>
    <script type="text/javascript" src="js/plugin/jsonview-v1.2.0/dist/jquery.jsonview.js"></script>
    <script type="text/javascript" src="js/plugin/bootstrap-treeview/bootstrap-treeview.js"></script>
    <script type="text/javascript" src="js/plugin/fullscreen.js"></script>
    <script type="text/javascript" src="js/plugin/echarts/charts.js"></script>
    <script type="text/javascript" src="js/sybn_bootstrap.js"></script>
    <script type="text/javascript" src="js/sybn_common.js"></script>
    <script type="text/javascript" src="js/sybn_desc_table.js"></script>
    <script type="text/javascript" src="js/md5.js"></script>
    <script type="text/javascript" src="js/plugin/sql/codemirror.js"></script>
    <script type="text/javascript" src="js/plugin/sql/matchbrackets.js"></script>
    <script type="text/javascript" src="js/plugin/sql/javascript.js"></script>
    <script type="text/javascript" src="js/plugin/sql/sql.js"></script>
    <script type="text/javascript" src="js/plugin/sql/show-hint.js"></script>
    <script type="text/javascript" src="js/plugin/sql/sql-hint3.js"></script>
    <script type="text/javascript" src="js/plugin/sql/sql-hint-sybn.js"></script>
    <script type="text/javascript" src="js/plugin/gzip/pako.min.js"></script>
    <script type="text/javascript" src="js/plugin/gzip/base64_gzip.js"></script>
    <script type="text/javascript" src="js/sql.js"></script>
<!--    <script type="text/javascript" src="js/gbi.js"></script>-->
    <script type="text/javascript" src="js/plugin/clipboard/clipboard.min.js"></script>
    <link rel="stylesheet" href="css/fontawesome-4.2.0_ie7/4.2.0/css/font-awesome.min.css" />
    <link rel="stylesheet" href="js/plugin/bootstrap-3.3.5/css/bootstrap.min.css" />
    <link rel="stylesheet" href="js/plugin/bootstrap-3.3.5/css/bootstrap-select.min.css" />
    <link rel="stylesheet" href="js/plugin/jsonview-v1.2.0/dist/jquery.jsonview.css" />
    <link rel="stylesheet" href="js/plugin/tablesorter/theme.default.min.css" />
    <link rel="stylesheet" href="css/plugin/sql/codemirror.css" />
    <link rel="stylesheet" href="css/plugin/sql/show-hint.css" />
    <link rel="stylesheet" href="css/bootstrap_sybn_custom.css" />
    <link rel="stylesheet" href="css/api_test.css" />
    <style>
        .form-control.CodeMirror{height: 195px;width:100%;}
        .sql_input_big .form-control.CodeMirror{height: 500px}
        .sql_input_big .iframe_preview {max-height: 400px;}
        .sql_input_big .json_iframe {height: 400px;}
        .sql_input_big2 .form-control.CodeMirror{height: 800px}
        .sql_input_big2 .iframe_preview {max-height: 500px;}
        .sql_input_big2 .json_iframe {height: 500px;}
        .mh500{max-height:500px;overflow-x: scroll;overflow: auto;}
        .mh450{max-height:450px;overflow-x: scroll;overflow: auto;}
        .btn-group-vertical .btn-group .w50{width:50%;float:left;}
        .change_log>p>span.change_log_line {margin-left: 1em;}
        .dbSource button,input,.form-control,a,li {padding: 0px}
        label {display: inline-block;max-width: 100%;margin: 0px;}
        .dropdown-menu>li>a  {white-space: normal; padding: 0px}
        .dropdown-menu>div>input {padding: 0px; height: 22px;}
    </style>
</head>
<body>
<ul class="nav nav-tabs">
    <li><strong class="title">即席分析(adhoc)</strong></li>
    <li class="active"><a href="#p_select_table" data-toggle="tab" aria-expanded="false">SQL查询</a></li>
<!--    <li class=""><a href="#p_select_qwen" data-toggle="tab" aria-expanded="false">千问人工智能查询</a></li>-->
    <li class=""><a href="#p_info" data-toggle="tab" aria-expanded="false">关于</a></li>
    <li class="floatRight padding3">
        <button type="button" class="btn btn-warning btn-xs login_out">注销<span class="login_username"></span></button>
        <!-- <button type="button" class="btn btn-danger btn-xs" onclick="$('#cacheRefresh').click()">刷新缓存</button>-->
    </li>
    <li class="floatRight padding3">
        <span>
            <span onclick="location='?dbsource_all=true'" title="显示所有数据源">数据源:</span>
            <select class="dbSource" name="dbSource" data-live-search="true">
                <option value="" selected="selected">默认(基础数据源)</option>
            </select>
        </span>
    </li>
</ul>

<div class="tab-content">

    <div id="p_select_table" class="panel panel-primary tab-pane active">
        <div class="panel-heading text-primary">
            <span class="p_title">即席分析(adhoc)</span>
        </div>

        <div class="panel-body sybn-api-demo collapse in">

            <div class="panel panel-success w100">
                <div class="panel-heading text-primary">
                    <span class="p_title">表结构接口 (查询缓存, 相似后缀的表会被合并显示, 请以 show tables 结果为准) <span class="show_table_prompt"></span></span>
                </div>
                <div class="panel-body sybn-api-demo collapse">
                    <div class="sybn_treeview">
                        <div class="row">
                            <div class="col-sm-6">
                                <div class="input-group input-group-xs">
                                    <span class="input-group-addon">快捷搜索:</span>
                                    <input type="text" class="form-control" id="input-search" placeholder="请输入要查询的信息(库名,表明,字段名,表备注,字段备注)..." value="">
                                    <span class="input-group-addon btn btn-success btn-xs" id="btn-search">搜索</span>
                                    <span class="input-group-addon btn btn-default btn-xs" id="btn-clear-search">清除</span>
                                </div>
                                <div id="search-output" class="mh450"></div>
                            </div>
                            <div class="col-sm-6">
                                <div id="treeview-searchable" class="mh500 input-group-xs"></div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

            <div class="panel panel-success w100 sybn-api-demo init_collapse">
                <div class="panel-heading text-primary">
                    <span class="p_title">单数据源 流式计算接口 - 类似于 flink 允许查询无界队列 [<span class="red">按"alt"开启代码提示</span>]</span>
                </div>
                <div class="panel-body sybn-api-demo collapse sybn_contextmenu">
                    <div class="input-group input-group-xs sql_textarea_parent">
                        <span class="btn-group-vertical input-group-addon btn-group-xs padding0">
                            <span class="btn btn-default sqlApi submit defaults_action" title="快捷键: shift + 回车">查询数据(直)</span>
                            <span class="btn btn-default sqlApi submit defaults_action enable_stream" data-api="api/sql/select" style="background-color: #dff0d8;">查询数据(流)</span>
                            <span class="btn btn-default sqlApi submit selection">查询选中(直)</span>
                            <span class="btn-group btn-group-xs">
                                <span class="btn btn-default sqlApi debug submit selection w50" data-api="api/sql/select">调试</span>
                                <span class="btn btn-default commentSql submit selection w50">注释</span>
                            </span>
                            <span class="btn btn-default sqlApi excel submit selection" data-api="api/sql/select">导出选中xlsx(直)</span>
                            <span class="btn btn-default sqlApi excel mergeHead submit selection" data-api="api/sql/select" title="导出选中并合并表头">合并表头xlsx(直)</span>
                            <span class="btn btn-default sqlApi csv submit selection enable_stream" data-api="api/sql/select" style="background-color: #dff0d8;">导出选中csv(流)</span>
                            <span class="btn btn-default interrupt submit">终止任务</span>
                        </span>
                        <textarea name="sql" class="sql_textarea stream_sql_input" style="margin-top:5px;display: block!important;">--# dbsource='auto'
SELECT create_time, params FROM editor_action_log where platform = 'OPEN API 低级接口' and params != 'show databases' order by id desc LIMIT 10</textarea>
                    </div>
                    <p>
                        <strong class="l_title">说明:</strong>
                        <span class="l_content">流式计算时, 只允许 select 查询单表</span>
                        <span class="l_content">因为CodeMirror插件的存在bug，如果sql输入框内容显示异常，在输入框结尾敲几个回车即可恢复。</span>
                    </p>
                </div>
            </div>

            <div class="panel panel-info w100 sybn-api-demo">
                <div class="panel-heading text-primary">
                    <span class="p_title">多数据源 内存计算接口 - 类似于 presto 允许跨服务器类型组合查询 [<span class="red">按"alt"开启代码提示</span>] 支持 mybatis 语句</span>
                </div>
                <div class="panel-body sybn-api-demo collapse in sybn_result_compare sybn_contextmenu">
                    <div class="input-group input-group-xs sql_textarea_parent">
                        <span class="btn-group-vertical input-group-addon btn-group-xs padding0">
                            <select class="btn btn-default sybnSqlEngine" name="sybnSqlEngine">
                                <option value="sysql" selected="selected">sysql支持跨库</option>
                                <option value="sql">原生sql</option>
                                <option value="directSql">直连sql</option>
                                <option value="mybatis">mybatis</option>
                                <option value="mybatisDirectSql">mybatis直连sql</option>
                                <option value="javascript">javascript</option>
                            </select>
                            <select class="btn btn-default sqlMaxLength" name="sqlMaxLength" title="最大查询量">
                                <option value="auto">自动</option>
                                <option value="10000">一万行</option>
                                <option value="100000">十万行</option>
                                <option value="1000000" selected="selected">一百万行</option>
                                <option value="10000000">一千万行</option>
                            </select>
                            <span class="btn btn-default sqlApi submit defaults_action" title="快捷键: shift + 回车">查询数据</span>
                            <span class="btn btn-default sqlApi submit selection">查询选中</span>
                            <span class="btn-group btn-group-xs">
                                <span class="btn btn-default sqlApi debug submit selection w50">调试</span>
                                <span class="btn btn-default commentSql submit selection w50">注释</span>
                            </span>
                            <span class="btn-group btn-group-xs">
                                <span class="btn btn-default sqlApi excel submit selection w50">xlsx</span>
                                <span class="btn btn-default sqlApi csv submit selection w50">csv</span>
                            </span>
                            <span class="btn btn-default sqlApi excel mergeHead submit selection" title="导出选中并合并表头">合并表头xlsx</span>
                            <span class="btn btn-default interrupt submit">终止任务</span>
                        </span>
                        <textarea name="sql" class="sql_textarea" style="margin-top:5px;display: block!important;">show databases</textarea>
                    </div>
                </div>
            </div>

            <div class="panel panel-info w100 sybn-api-demo">
                <div class="panel-heading text-primary">
                    <span class="p_title">多数据源 内存计算接口 - 类似于 presto 允许跨服务器类型组合查询 [<span class="red">按"alt"开启代码提示</span>] 支持 mybatis 语句</span>
                </div>
                <div class="panel-body sybn-api-demo collapse in sybn_result_compare sybn_contextmenu">
                    <div class="input-group input-group-xs sql_textarea_parent">
                        <span class="btn-group-vertical input-group-addon btn-group-xs padding0">
                            <select class="btn btn-default sybnSqlEngine" name="sybnSqlEngine">
                                <option value="sysql" selected="selected">sysql支持跨库</option>
                                <option value="sql">原生sql</option>
                                <option value="directSql">直连sql</option>
                                <option value="mybatis">mybatis</option>
                                <option value="mybatisDirectSql">mybatis直连sql</option>
                                <option value="javascript">javascript</option>
                            </select>
                            <select class="btn btn-default sqlMaxLength" name="sqlMaxLength" title="最大查询量">
                                <option value="auto">自动</option>
                                <option value="10000">一万行</option>
                                <option value="100000">十万行</option>
                                <option value="1000000" selected="selected">一百万行</option>
                                <option value="10000000">一千万行</option>
                            </select>
                            <span class="btn btn-default sqlApi submit defaults_action" title="快捷键: shift + 回车">查询数据</span>
                            <span class="btn btn-default sqlApi submit selection">查询选中</span>
                            <span class="btn-group btn-group-xs">
                                <span class="btn btn-default sqlApi debug submit selection w50">调试</span>
                                <span class="btn btn-default commentSql submit selection w50">注释</span>
                            </span>
                            <span class="btn-group btn-group-xs">
                                <span class="btn btn-default sqlApi excel submit selection w50">xlsx</span>
                                <span class="btn btn-default sqlApi csv submit selection w50">csv</span>
                            </span>
                            <span class="btn btn-default sqlApi excel mergeHead submit selection" title="导出选中并合并表头">合并表头xlsx</span>
                            <span class="btn btn-default interrupt submit">终止任务</span>
                        </span>
                        <textarea id="sql_demo" name="sql" class="sql_textarea" style="margin-top:5px;display: block!important;">
--# fileName='临时数据查询'
select id, date, sum(score) as sum_score, max(score) as max_score
from [{id:1,score:1,date:'2025-03-21'},{id:2,score:2,date:'2025-03-22'},{id:3,score:3,date:'2025-03-23'},{id:1,score:4,date:'2025-03-21'},{id:2,score:4,date:'2025-03-21'}]
group by id, date
having sum_score > 0
order by a;
</textarea>
                    </div>
                </div>
            </div>

        </div>
    </div>


    <div id="p_select_gbi" class="panel panel-primary tab-pane sybn-api-demo">

        <div class="panel-heading text-primary btn-group-xs">
            <span class="p_title">gbi - 智能问答[试用版接口], 当前只支持查询 t05 的数据</span>
        </div>

        <div class="panel-body sybn-api-demo collapse in">
            <div class="input-group input-group-xs sql_textarea_parent">
                <span class="btn-group-vertical input-group-addon btn-group-xs padding0">
                    <span class="btn btn-default" onclick="sendRequest()">提问</span>
                </span>
                <textarea id="gbi_input" name="gbi_input" rows="4" class="form-control" style="height:100px;">最近1周北京市的POS渠道票房走势按日显示</textarea>
            </div>
            <div class="input-group input-group-xs gbi-container" style="width:100%; height:500px;">
                <div>
                    <span>sessionId:</span><input type="text" id="sessionId" value="" />
                    <span>tenantId:</span><input type="text" id="tenantId" value="" />
                    <span>cinemaUid:</span><input type="text" id="cinemaUid" value="" />
                </div>
                <span class="blue">思考过程:</span>
                <div id="output"></div>
                <span class="blue">思考结果:</span>
                <div id="output2"></div>
                <span class="blue">图表信息(将来需要前端对接图表):</span>
                <div id="output3"></div>
                <div id="outputTable"></div>
            </div>
        </div>
    </div>


    <div id="p_select_qwen" class="panel panel-primary tab-pane sybn-api-demo">

        <div class="panel-heading text-primary btn-group-xs">
            <span class="p_title">千问 - 智能问答[试用版接口], 当前只支持查询t05 的数据快照</span>
        </div>

        <div class="panel-body sybn-api-demo collapse in">
            <div class="input-group input-group-xs sql_textarea_parent">
                <span class="btn-group-vertical input-group-addon btn-group-xs padding0">
                    <span class="btn btn-default" onclick="sendRequest()">提问</span>
                </span>
                <textarea id="qwen_input" name="qwen_input" rows="4" class="form-control" style="height:100px;">最近1周北京市的POS渠道票房走势按日显示</textarea>
            </div>
            <div class="input-group input-group-xs gbi-container" style="width:100%; height:500px;">
<!--                <div>-->
<!--                    <span>sessionId:</span><input type="text" id="qwen_sessionId" value="" />-->
<!--                    <span>tenantId:</span><input type="text" id="qwen_tenantId" value="" />-->
<!--                    <span>cinemaUid:</span><input type="text" id="qwen_cinemaUid" value="" />-->
<!--                </div>-->
                <span class="blue">思考过程:</span>
                <div class="output"></div>
                <span class="blue">思考结果:</span>
                <div class="output2"></div>
                <span class="blue">图表信息(将来需要前端对接图表):</span>
                <div class="output3"></div>
                <div class="outputTable"></div>
            </div>
        </div>
    </div>

    <div id="p_info" class="panel panel-primary tab-pane">
        <div class="panel-heading text-primary">
            <span class="p_title">关于 About</span>
        </div>
        <div class="panel-body sybn-api-demo collapse in">

            <div class="panel panel-success w100">
                <div class="panel-heading text-primary">
                    <span class="p_title">服务器状态</span>
                </div>
                <div class="panel-body sybn-api-demo collapse in">
                    <iframe title="info" class="json_iframe" src="info_vue.html?r=60"></iframe>
                </div>
            </div>

            <div class="panel panel-success w100">
                <div class="panel-heading text-primary">
                    <span class="p_title">重要更新: 2024-04-02</span>
                </div>
                <div class="panel-body collapse in change_log">
                    <p>
                        <strong>2025-01-02</strong><br/>
                        <span class="change_log_line"><a href="js/plugin/gzip/gzip.html" target="_blank">gzip工具</a></span>
                    </p>
                    <p>
                        <strong>2024-04-02</strong><br/>
                        <span class="change_log_line">
                            <span>sql 翻译工具: </span>
                            <a href="js/plugin/mergely/examples/replace_clickhouse.html" target="_blank">to clickhouse </a> |
                            <a href="js/plugin/mergely/examples/replace_holo.html" target="_blank">to holo </a> |
                            <a href="js/plugin/mergely/examples/replace_flink.html" target="_blank">to flink </a>
                        </span>
                        <br/>
                        <span class="change_log_line">
                            <span>对比工具: </span>
                            <a href="js/plugin/mergely/examples/compare_tables.html" target="_blank">列表相似度对比 </a>
                        </span>
                    </p>
                    <p>
                        <strong>2023-05-29</strong><br/>
                        <span class="change_log_line"><a href="js/plugin/viz/viz_java.html" target="_blank">java调用关系图</a></span>
                    </p>
                    <p>
                        <strong>2022-12-23</strong><br/>
                        <span class="change_log_line"><a href="js/plugin/viz/viz_join.html" target="_blank">表join关系图</a></span>
                    </p>
                    <p>
                        <strong>2022-06-28</strong><br/>
                        <span class="change_log_line">允许查询es数组字段</span>
                    </p>
                    <p>
                        <strong>2022-04-13</strong><br/>
                        <span class="change_log_line">表结构提示 (表名后面按 alt 键查看 create table) 支持动态数据源</span>
                    </p>
                    <p>
                        <strong>2022-04-07</strong><br/>
                        <span class="change_log_line"><a href="js/plugin/mergely/examples/simple.html" target="_blank">文本对比工具</a></span>
                    </p>
                    <p>
                        <strong>2021-10-01</strong><br/>
                        <span class="change_log_line">允许使用 mybatis 查询.</span>
                    </p>
                    <p>
                        <strong>2020-05-26</strong><br/>
                        <span class="change_log_line"><a href="js/plugin/viz/viz_template2.html?table=dim_oristar_cmc_base_sale_channel" target="_blank">表关系图</a></span><br/>
<!--                        <span  class="change_log_line"><a href="js/plugin/viz/viz_template2.html?table=CINEMA.dw_pos_movie_ticket_order_collect&action=all" target="_blank">表关系图</a></span><br/>-->
                    </p>
                    <p>
                        <strong>2020-02-06</strong><br/>
                        <span class="change_log_line"><a href="sql_translate.html" target="_blank">sql转换</a></span>
                    </p>
                </div>
            </div>
        </div>
    </div>

    <div style="display: none;">
        <table summary="" id="defaultsTemplate" class="tableTemplate tablesorter tablesorter-default" style="display: none;">
            <thead class="thTemplate">
                <tr class="info textCenter"><th scope="col" style="display: none;"> </th></tr>
            </thead>
            <tbody class="trTemplate">
                <tr class="tinfo phrase_tr" data-id="#{id}"> </tr>
            </tbody>
        </table>
    </div>

    <!-- login Modal -->
    <div class="modal fade" id="loginModal" tabindex="-1" role="dialog" aria-labelledby="loginModalLabel" aria-hidden="true">
        <div class="modal-dialog modal-sm">
            <div class="modal-content">
                <div class="modal-header">
                    <button type="button" class="close login_close" data-dismiss="modal"><span aria-hidden="true">&times;</span><span class="sr-only">Close</span></button>
                    <h4 class="modal-title" id="loginModalLabel">登录账户</h4>
                </div>
                <div class="modal-body">
                    <div class="input-group">
                        <span class="input-group-addon">账户</span>
                        <input type="text" class="form-control" placeholder="登录的帐户名" name="username"/>
                    </div>
                    <div class="input-group">
                        <span class="input-group-addon">密码</span>
                        <input type="password" class="form-control" placeholder="密码" name="password"/>
                    </div>
                </div>
                <div class="modal-footer">
                    <span class="prompt"></span>
                    <button type="button" class="btn btn-default login_close" data-dismiss="modal">取消</button>
                    <button type="button" class="btn btn-primary login_submit">登录</button>
                </div>
            </div>
        </div>
    </div>
    <div class="contextmenu contextmenu_div" id="sub-menu">
        <ul class="list-group">
            <li class="list-group-item">
                <a href="javascript:void(0);" class="copy_btn btn btn-default btn-xs sql_append" data-field="${field}" data-type="${type}" data-value="${type}" data-op="=">等于此值</a>
                <a href="javascript:void(0);" class="copy_btn btn btn-default btn-xs sql_append" data-field="${field}" data-type="${type}" data-value="${type}" data-op="!=">不等于此值</a>
                <a href="javascript:void(0);" class="copy_btn btn btn-default btn-xs sql_append" data-field="${field}" data-type="${type}" data-value="${type}" data-op=">">大于</a>
                <a href="javascript:void(0);" class="copy_btn btn btn-default btn-xs sql_append" data-field="${field}" data-type="${type}" data-value="${type}" data-op="<">小于</a>
                <a href="javascript:void(0);" class="copy_btn btn btn-default btn-xs sql_append" data-field="${field}" data-type="${type}" data-value="${type}" data-op="in">in</a>
                <a href="javascript:void(0);" class="copy_btn btn btn-default btn-xs sql_append" data-field="${field}" data-type="${type}" data-value="${type}" data-op="like">like</a>
            </li>
            <li class="list-group-item"><a href="javascript:void(0);" class="copy_btn btn btn-default btn-xs" id="btn_copy_field" data-clipboard-target="#copy_field">复制字段</a> <span>:</span> <span id="copy_field">${field}</span></li>
            <li class="list-group-item"><a href="javascript:void(0);" class="copy_btn btn btn-default btn-xs" id="btn_copy_type"  data-clipboard-target="#copy_type">复制类型</a> <span>:</span> <span id="copy_type">${type}</span></li>
            <li class="list-group-item">
                <a href="javascript:void(0);" class="copy_btn btn btn-default btn-xs" id="btn_copy_value" data-clipboard-target="#copy_value">复制数值</a> <span>:</span>
                <a href="javascript:void(0);" class="copy_btn btn btn-default btn-xs" id="btn_copy_field_value" data-clipboard-target="#copy_field_value">复制KV</a>
                <textarea id="copy_value" class="copy_textarea">${value}</textarea>
                <textarea id="copy_field_value" class="copy_textarea" style="position: absolute; left: -9999px;">${field}: ${value}</textarea>
            </li>
        </ul>
    </div>
    <div class="contextmenu contextmenu_div" id="title-menu">
        <ul class="list-group">
            <li class="list-group-item"><a href="javascript:void(0);" class="copy_btn btn btn-default btn-xs" id="title_btn_copy_field"     data-clipboard-target="#title_copy_field">复制字段</a>: <span id="title_copy_field">${field}</span></li>
            <li class="list-group-item"><a href="javascript:void(0);" class="copy_btn btn btn-default btn-xs" id="title_btn_copy_value"     data-clipboard-target="#title_copy_value">复制总和</a>: <span id="title_copy_value" class="sybn_ellipsis" style="max-width:100px;">${value}</span></li>
            <li class="list-group-item"><a href="javascript:void(0);" class="copy_btn btn btn-default btn-xs" id="title_btn_copy_col"       data-clipboard-target="#title_copy_col">复制整列</a>: <span id="title_copy_col_size"></span><textarea id="title_copy_col" class="copy_textarea" style="position: absolute; left: -9999px;">${calVal}</textarea></li>
            <li class="list-group-item"><a href="javascript:void(0);" class="copy_btn btn btn-default btn-xs" id="title_btn_copy_all_field" data-clipboard-target="#title_copy_all_field">复制所有字段名</a>: <span id="title_copy_all_field_size"></span><textarea id="title_copy_all_field" class="copy_textarea" style="position: absolute; left: -9999px;">${title_copy_all_field}</textarea></li>
            <li class="list-group-item"><a href="javascript:void(0);" class="copy_btn btn btn-default btn-xs" id="title_btn_highlight_col" >高亮重复值</a></li>
        </ul>
    </div>
</div>
</body>
</html>
